-
Re: How to identify child and sub-childs of a parent so I can add conditional formatting?
@SJ1 You can create a helper column to count the number of ANCESTORS of a cell. 0 ancestors = parent 1 ancestor = child 2 ancestors = sub-child, etc. The formula is: =COUNT(ANCESTORS(ColumnName@row))…3 · -
Re: moving smartsheets out of a folder and not breaking the links
@Rob Wright If you're referring to cell links within formulas or URL links to the sheets, you're good. Each sheet has a unique identifier that doesn't change when the sheet is renamed, moved around i…1 · -
Re: Formula to count days a row stays in a certain status?
In that case, good luck 🤣 But honestly, you would have to come up with some criteria to capture with the Record a date and Change cell value automations. Like when the row is added, set the Initial S…1 · -
Re: Select specific person/email as the name for automated alerts
Hi @Genevieve P. Thanks for initiating this thread. We are very much in need of this functionality. Phase 1 was a nice first step, but fell very short of the functionality we all were hoping for. As …5 · -
Re: Help setting up alerts on a sheet based around certain dates
@murphyspccms Here's the automation trigger setting. Use When a date is reached, select the date field, and click the down arrow next to "on" to schedule it for a certain number of days bef…2 ·